Thumb

AND & OR Operator

9/14/2020 6:57:45 AM

AND & OR Operator: The AND & OR Operators are used to combine multiple conditions specified with the WHERE clause. AND makes it necessary for all condition to be true, OR works even if one is true. Now given bellow the example code:

select * from Salary where Salary.Salary>15000 AND Salary.Gendar='Male'

select * from Salary where Salary.Salary>15000 OR Salary.Gendar='Male'

In this case we can see the AND Operator match the both condition then show the result on the other hand OR operator match the only one condition match then show the result.